<!DOCTYPE html>
<html>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<head>
<title>dev-db数据库结构</title>
<style type="text/css">
body { color: #000; background: #fff; font: 100% Verdana, Arial, Helvetica, sans-serif; margin: 10; }
h1 { font-size: 150%; margin: 0; padding: .8em 1em; border-bottom: 1px solid #999; font-weight: normal; color: #777; background: #eee; }
h2 { font-size: 150%; margin: 0 0 20px -18px; padding: .8em 1em; border-bottom: 1px solid #000; color: #000; font-weight: normal; background: #ddf; }
h3 { font-weight: normal; font-size: 130%; margin: 1em 0 0; }
table { margin: 1em 20px 0 0; border: 0; border-top: 1px solid #999; border-left: 1px solid #999; font-size: 90%; }
td, th { border: 0; border-right: 1px solid #999; border-bottom: 1px solid #999; padding: .2em .3em; background: #eee; text-align: left; }
th { background: #eee; text-align: left; }
p { margin: .8em 20px 0 0; }
</style>
</head>
<body>

<h2>dev-db数据库结构</h2>
更新时间：2019-04-26 15:59:32<br/>
dev-db数据库中有14张表：
<table>
<tr><th>数据库表</th><th>字符集</th><th>备注</th><tr>
<tr><td><a href='fin_accounting_subject.html'>fin_accounting_subject</a></td><td>utf8mb4_general_ci</td><td>会计科目</td></tr>
<tr><td><a href='fin_bank_account.html'>fin_bank_account</a></td><td>utf8mb4_general_ci</td><td>小石头公益的银行账户。支付宝账户也视作银行账户。</td></tr>
<tr><td><a href='fin_bank_transaction.html'>fin_bank_transaction</a></td><td>utf8mb4_general_ci</td><td>银行流水明细，包括民生银行、支付宝的流水。</td></tr>
<tr><td><a href='fin_jouney_entry.html'>fin_jouney_entry</a></td><td>utf8mb4_general_ci</td><td>会计分录</td></tr>
<tr><td><a href='md_grade.html'>md_grade</a></td><td>utf8mb4_general_ci</td><td>年级</td></tr>
<tr><td><a href='md_project.html'>md_project</a></td><td>utf8mb4_general_ci</td><td></td></tr>
<tr><td><a href='md_school_year.html'>md_school_year</a></td><td>utf8mb4_general_ci</td><td></td></tr>
<tr><td><a href='md_semester.html'>md_semester</a></td><td>utf8mb4_general_ci</td><td></td></tr>
<tr><td><a href='project_phase.html'>project_phase</a></td><td>utf8mb4_general_ci</td><td>某个项目，在某个学期的助学工作</td></tr>
<tr><td><a href='sponsor.html'>sponsor</a></td><td>utf8mb4_general_ci</td><td>资助人</td></tr>
<tr><td><a href='student.html'>student</a></td><td>utf8mb4_general_ci</td><td>受助学生信息主表</td></tr>
<tr><td><a href='student_aid.html'>student_aid</a></td><td>utf8mb4_general_ci</td><td>学生资助跟踪表</td></tr>
<tr><td><a href='student_bank_account.html'>student_bank_account</a></td><td>utf8mb4_general_ci</td><td>学生用于接收助学金的银行账户</td></tr>
<tr><td><a href='volunteer.html'>volunteer</a></td><td>utf8mb4_general_ci</td><td>志愿者</td></tr>
</table>


</body>
</html>